【Linux Centos6/7 Oracle11g 内存16G调整32G】

2023-08-10 05:35| 来源: 网络整理| 查看: 265

Linux Centos6/7 Oracle11g 内存16G调整32G 1.登录oracle用户权限2.16G oracle配置3.16G sysctl.conf配置4.32G oracle配置5.32G sysctl.conf配置6.修改16G oracle 的sysctl.conf7.修改16G oracle的配置8.重启oracle9.已成功修改服务器内存16G改为32G

前情提要：公司新创建的数据库需要将数据库内存16G调整32G （若要32G换成16G 本文章通用）

1.登录oracle用户权限 [root@localhost ~]# su oracle [oracle@localhost ~]$ sqlplus / as sysdba 2.16G oracle配置

注：可能没有pga_aggregate_limit这个值，直接跳过就好

SQL> show parameter sga; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ allow_group_access_to_sga boolean FALSE lock_sga boolean FALSE pre_page_sga boolean TRUE sga_max_size big integer 8096M sga_min_size big integer 0 sga_target big integer 8000M unified_audit_sga_queue_size integer 1048576 SQL> show parameter pga; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ pga_aggregate_limit big integer 2400M pga_aggregate_target big integer 798M SQL> show parameter target; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ archive_lag_target integer 0 db_big_table_cache_percent_target string 0 db_flashback_retention_target integer 1440 fast_start_io_target integer 0 fast_start_mttr_target integer 0 memory_max_target big integer 0 memory_target big integer 0 parallel_servers_target integer 128 pga_aggregate_target big integer 798M sga_target big integer 8000M target_pdbs integer 0 3.16G sysctl.conf配置 [root@localhost ~]# cat /etc/sysctl.conf fs.aio-max-nr = 1048576 fs.file-max = 6815744 kernel.shmall = 2097152 kernel.shmmax = 4294967295 kernel.shmmni= 4096 kernel.sem= 250 32000 100 128 net.ipv4.ip_local_port_range = 9000 65500 net.core.rmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048576 4.32G oracle配置 [oracle@localhost ~]$ sqlplus / as sysdba; Connected. SQL> show parameter sga; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ allow_group_access_to_sga boolean FALSE lock_sga boolean FALSE pre_page_sga boolean TRUE sga_max_size big integer 9664M sga_min_size big integer 0 sga_target big integer 9664M unified_audit_sga_queue_size integer 1048576 SQL> show parameter pga; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ pga_aggregate_limit big integer 6436M pga_aggregate_target big integer 3218M SQL> show parameter target; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ archive_lag_target integer 0 db_big_table_cache_percent_target string 0 db_flashback_retention_target integer 1440 fast_start_io_target integer 0 fast_start_mttr_target integer 0 memory_max_target big integer 0 memory_target big integer 0 parallel_servers_target integer 128 pga_aggregate_target big integer 3218M sga_target big integer 9664M target_pdbs integer 0 5.32G sysctl.conf配置 [root@localhost ~]# cat /etc/sysctl.conf fs.aio-max-nr = 1048576 fs.file-max = 6815744 kernel.shmall = 3294590 kernel.shmmax = 16868304896 kernel.shmmni= 4096 kernel.sem= 250 32000 100 128 net.ipv4.ip_local_port_range = 9000 65500 net.core.rmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048576 6.修改16G oracle 的sysctl.conf [root@localhost ~]# vim /etc/sysctl.conf 将 kernel.shmall = 2097152 kernel.shmmax = 4294967295 改为 kernel.shmall = 3294590 kernel.shmmax = 16868304896 执行命令使修改生效 [root@localhost ~]# sysctl -p 7.修改16G oracle的配置

注：主要根据sga，pga，target参数改就好

SQL> alter system set sga_max_size = 9664M scope=spfile; System altered. SQL> alter system set sga_target=9664M scope=spfile; System altered. SQL> alter system set pga_aggregate_target=3218M scope=both; System altered. SQL> alter system set pga_aggregate_limit=6436M scope=both; System altered. 8.重启oracle [oracle@localhost ~]$ sqlplus / as sysdba SQL> shutdown immediate; SQL> startup; 9.已成功修改服务器内存16G改为32G

总结：本文主要参考大佬文章，其中少部分为自己个人看法和配置，个人记性不好，所以总结加记要；再次感谢CSDN各位大佬的贡献，我只是个小小搬运工。

参考大佬文献

https://www.cnblogs.com/crnet/p/14918098.html

【本文地址】

公司简介

联系我们